
# table 支持各类过滤方式
# {"table_name": "", cols: "", skip_cols: "", "order_cols": "" },

mysql_conf = {
    "schema": {
        "sql": "select SCHEMA_NAME from information_schema.SCHEMATA t \
                where t.SCHEMA_NAME not in \
                    ('information_schema','mysql','performance_schema','secure_file','secure_file_priv')"
    },
    "split_cols": "table_schema,CONSTRAINT_schema",
    "table": [
        {"table_name": "information_schema.SCHEMA_PRIVILEGES", "skip_cols": "grantee"},
        {"table_name": "information_schema.VIEWS", "skip_cols": "grantee"},
        {"table_name": "information_schema.TABLES", "cols":
            "table_schema,table_name,table_type,engine,row_format,table_collation,table_comment"},
        {"table_name": "information_schema.TABLE_CONSTRAINTS", },
        {"table_name": "information_schema.TABLE_PRIVILEGES", },
        {"table_name": "information_schema.COLUMNS", },
        {"table_name": "information_schema.PARTITIONS", "cols": "table_schema, table_name, partition_name, \
            subpartition_name,partition_method,subpartition_method,PARTITION_comment,tablespace_name"},
        {"table_name": "information_schema.GLOBAL_VARIABLES", },
        {"table_name": "information_schema.TABLE_STATISTICS", },
        {"table_name": "information_schema.INDEX_STATISTICS", },
        {"table_name": "information_schema.KEY_COLUMN_USAGE", },
        {"table_name": "information_schema.REFERENTIAL_CONSTRAINTS", },
        {"table_name": "information_schema.STATISTICS", },
        {"table_name": "information_schema.SCHEMA_PRIVILEGES", },
        {"table_name": "information_schema.USER_PRIVILEGES", },
    ],
    "order_cols": "SCHEMA_NAME,CONSTRAINT_schema,CONSTRAINT_name,table_schema,table_name,table_type,grantee,\
    privilege_type,column_name,variable_name,partition_name,subpartition_name",
    "skip_cols": "",
}
